<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!doctype html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="/style/basic_layout.css" rel="stylesheet" type="text/css">
    <link href="/style/common_style.css" rel="stylesheet" type="text/css">
    <script type="text/javascript" src="/js/jquery/jquery.js"></script>
    <script type="text/javascript" src="/js/plugins/artDialog/jquery.artDialog.js?skin=blue"></script>
    <script type="text/javascript" src="/js/plugins/My97DatePicker/My97DatePicker/WdatePicker.js"></script>
    <script type="text/javascript" src="/js/commonAll.js"></script>
    <script type="text/javascript">
        $(function () {
            //处理开始时间
            $("input[name='beginDate']").click(function () {
                WdatePicker({
                    readOnly:true,
                    maxDate:new Date()
                })
            });

            //处理结束时间
            $("input[name='endDate']").click(function () {
                WdatePicker({
                    readOnly:true,
                    minDate:$("input[name='beginDate']").val(),
                    maxDate:new Date()
                })
            });
        })

    </script>

    <title>WMS-订货报表</title>
    <style>
        .alt td{ background:black !important;}
    </style>
</head>
<body>
<form id="searchForm" action="/chart/order.do" method="post">
    <div id="container">
        <div class="ui_content">
            <div class="ui_text_indent">
                <div id="box_border">
                    <div id="box_top">搜索</div>
                    <div id="box_center">
                        业务时间
                        <fmt:formatDate value="${qo.beginDate}" var="beginDate"/>
                        <fmt:formatDate value="${qo.endDate}" var="endDate"/>
                        <input type="text" class="ui_input_txt01 Wdate" name="beginDate" value="${beginDate}"/> ~
                        <input type="text" class="ui_input_txt01 Wdate" name="endDate" value="${endDate}"/>
                        货品名称/编码
                        <input type="text" class="ui_input_txt01" name="keyword" value="${qo.keyword}"/>
                        供应商
                        <select id="supplierId" class="ui_select01" name="supplierId">
                            <option value="-1">全部</option>
                            <c:forEach items="${suppliers}" var="ele">
                                <option value="${ele.id}">${ele.name}</option>
                            </c:forEach>
                        </select>
                        品牌
                        <select id="brandId" class="ui_select01" name="brandId">
                            <option value="-1">全部</option>
                            <c:forEach items="${brands}" var="ele">
                                <option value="${ele.id}">${ele.name}</option>
                            </c:forEach>
                        </select>
                        类型
                        <select id="groupType" class="ui_select01" name="groupType">

                            <option value="e.name">订货员</option>

                            <option value="p.name">商品名称</option>

                            <option value="p.brandName">商品品牌</option>

                            <option value="s.name">供应商</option>

                            <option value="date_format(bill.vdate,'%y-%m')">订货月份</option>

                            <option value="DATE_FORMAT(bill.vdate,'%Y-%m-%d')">订货日期</option>

                        </select>
                        <script type="text/javascript">
                            showNow("#supplierId",${qo.supplierId});
                            showNow("#brandId",${qo.brandId});
                            $("#groupType option[value=\"${qo.groupType}\"]").prop("selected",true);
                        </script>
                    </div>
                    <div id="box_bottom">
                        <input type="button" value="查询" class="ui_input_btn01 btn_page"/>
                    </div>
                </div>
            </div>
        </div>
        <div class="ui_content">
            <div class="ui_tb">
                <table class="table" cellspacing="0" cellpadding="0" width="100%" align="center" border="0">
                    <tr>
                        <th>分组类型</th>
                        <th>订货总数</th>
                        <th>订货总额</th>
                    </tr>

                    <c:forEach items="${result}" var="list" >
                        <tr>
                            <td>${list.groupType}</td>
                            <td>${list.totalNumber}</td>
                            <td>${list.totalAmount}</td>
                        </tr>
                    </c:forEach>
                </table>
            </div>
        </div>
    </div>
</form>
</body>

</html>